Extending the Multidimensional Model for Linking Cubes
نویسندگان
چکیده
Data warehouses structure data in multidimensional cubes, where dimensions specify different ways in which measures in facts may be viewed, aggregated, and sorted. It is essential for data analysts to combine data from heterogeneous multidimensional cubes to enhance their analysis capabilities. For this, users are restricted in using only shared dimensions for navigating related multidimensional cubes. In this paper, we show that this limits the analysis possibilities and introduce an explicit link that relates two multidimensional cubes, indicating that they represent different aspects of the same reality, and hence they may be connected. We argue that the standard drill-across operator is not suited to perform such operation, and we extend it by proposing a new operator called drill-across-link.
منابع مشابه
An Object Oriented Multidimensional Data Model for OLAP
Online Analytical Processing (OLAP) data is frequently organized in the form of multidimensional data cubes each of which is used to examine a set of data values, called measures, associated with multiple dimensions and their multiple levels. In this paper, we first propose a conceptual multidimensional data model, which is able to represent and capture natural hierarchical relationships among ...
متن کاملDrill Across and Visualization of Cubes with Non-conformed Dimensions
Data analysts would benefit greatly from the ability to navigate and view combined multidimensional data from multiple sources, a key requirement of which is the conformity between their dimensions. The strict requirements of conformity restrict navigating to related multidimensional data from unseen or unfamiliar sources. In this paper we make a distinction between conformed dimension tables a...
متن کاملDrill Across & Visualization of Cubes with Non-Conformed Dimensions
Data analysts would benefit greatly from the ability to navigate and view combined multidimensional data from multiple sources, a key requirement of which is the conformity between their dimensions. The strict requirements of conformity restrict navigating to related multidimensional data from unseen or unfamiliar sources. In this paper we make a distinction between conformed dimension tables a...
متن کاملSparsity Handling and Data Explosion in OLAP Systems
A common problem with OnLine Analytical Processing (OLAP) databases is data explosion data size multiplies, when it is loaded from the source data into multidimensional cubes. Data explosion is not an issue for small databases, but can be serious problems with large databases. In this paper we discuss the sparsity and data explosion phenomenon in multidimensional data model, which lie at the co...
متن کاملModeling Multidimensional Databases, Cubes and Cube Operations
On-Line Analytical Processing (OLAP) is a trend in database technology, which was recently introduced and has attracted the interest of a lot of research work. OLAP is based on the multidimensional view of data, supported either by multidimensional databases (MOLAP) or relational engines (ROLAP). In this paper we propose a model for multidimensional databases. Dimensions, dimension hierarchies ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015